Which one of the following is used to change part of a formula while preserving the basic format?
F1 and cursor keys
F2 and cursor keys
F3 and cursor keys
F5 and cursor keys
2
Which one of the following is the long date format?
m-dd-yyyy
mm-dd-yy
mm-yyyy
mm-dd-yyyy
4
Which one of the following will return a Null value if the criteria is NOT met?
=if(a1>b1,a1,null)
=if(a1>b1;a1;"")
=if(a1>b1,a1,)
=if(a1>b1,a1,"")
4
Which one of the following is the maximum number of criteria for sorting?
One
Two
Three
Four
3
Which keyboard short-cut opens the "Replace" dialog box?
Ctrl + F
Ctrl + H
Ctrl + X
Ctrl + Y
2
Which one of the following is the default number format?
Currency with 2 decimal places
General without fixed decimal
Comma with 2 decimal places
Comma without fixed decimal 
2
How many conditions will Conditional Formatting accept?
Three
Four
Five
Unlimited
1